package com.lq.educationsystem.examination.mapper;

import com.lq.educationsystem.examination.entiy.StudentExaminationTb;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
* @author Administrator
* @description 针对表【student_examination_tb】的数据库操作Mapper
* @createDate 2024-04-13 12:22:33
* @Entity com.lq.educationsystem.examination.entiy.StudentExaminationTb
*/
public interface StudentExaminationTbMapper {

    int deleteByPrimaryKey(Long id);

    int insert(StudentExaminationTb record);

    int insertSelective(StudentExaminationTb record);

    StudentExaminationTb selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(StudentExaminationTb record);

    int updateByPrimaryKey(StudentExaminationTb record);

    List<StudentExaminationTb> queryList(@Param("start") Integer start, @Param("pageSize") Integer pageSize,@Param("studentExaminationTb") StudentExaminationTb studentExaminationTb);

    int queryCount(@Param("studentExaminationTb") StudentExaminationTb studentExaminationTb);

    /**
     * 查询考试信息
     * @param examinationIdList
     * @param studentId
     * @return
     */
    List<StudentExaminationTb> queryStudentExaminationInfoByStudentIdAndExaminationId(@Param("examinationIdList") List<Integer> examinationIdList,@Param("studentId") Integer studentId);


    Integer addBatchStudentExaminationInfoByExaminationIdAndStudentId(@Param("studentIdInfoList") List<Integer> studentIdInfoList,@Param("examinationId") Integer examinationId);
}
